{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='名爵')]\n",
    "LSG = all1[(all1['brand']=='名爵')]\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CSA7152SDMN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CSA7152SDAN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CSA7152SDMP</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CSA7152SDAQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CSA7152SDAP</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CSA7152SDMQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CSA7152SDMQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CSA7152SDMP</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CSA7152SDAQ</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CSA7152SDMN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1300</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>CSA7152SDAN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CSA7152SDAP</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1320</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695</td>\n",
       "      <td>1848</td>\n",
       "      <td>1462</td>\n",
       "      <td>1490</td>\n",
       "      <td>124</td>\n",
       "      <td>LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2715</td>\n",
       "      <td>4695x1848x1462</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CSA7151MDAF</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1160,1190</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055</td>\n",
       "      <td>1729</td>\n",
       "      <td>1521</td>\n",
       "      <td>1498</td>\n",
       "      <td>86</td>\n",
       "      <td>LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055x1729x1521</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>CSA7151MDAG</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1160,1190</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055</td>\n",
       "      <td>1729</td>\n",
       "      <td>1521</td>\n",
       "      <td>1498</td>\n",
       "      <td>86</td>\n",
       "      <td>LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055x1729x1521</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CSA7151MDAF</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1160,1190</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055</td>\n",
       "      <td>1729</td>\n",
       "      <td>1521</td>\n",
       "      <td>1498</td>\n",
       "      <td>86</td>\n",
       "      <td>LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055x1729x1521</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CSA7151MDAG</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1160,1190</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055</td>\n",
       "      <td>1729</td>\n",
       "      <td>1521</td>\n",
       "      <td>1498</td>\n",
       "      <td>86</td>\n",
       "      <td>LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055x1729x1521</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>CSA7151MDAG</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1160,1190</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055</td>\n",
       "      <td>1729</td>\n",
       "      <td>1521</td>\n",
       "      <td>1498</td>\n",
       "      <td>86</td>\n",
       "      <td>LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055x1729x1521</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CSA7151MDAF</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1160,1190</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055</td>\n",
       "      <td>1729</td>\n",
       "      <td>1521</td>\n",
       "      <td>1498</td>\n",
       "      <td>86</td>\n",
       "      <td>LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055x1729x1521</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CSA7151MDAG</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1160,1190</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055</td>\n",
       "      <td>1729</td>\n",
       "      <td>1521</td>\n",
       "      <td>1498</td>\n",
       "      <td>86</td>\n",
       "      <td>LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055x1729x1521</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CSA7151MDAF</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1160,1190</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055</td>\n",
       "      <td>1729</td>\n",
       "      <td>1521</td>\n",
       "      <td>1498</td>\n",
       "      <td>86</td>\n",
       "      <td>LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055x1729x1521</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>CSA7151MDAG</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1160,1190</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055</td>\n",
       "      <td>1729</td>\n",
       "      <td>1521</td>\n",
       "      <td>1498</td>\n",
       "      <td>86</td>\n",
       "      <td>LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055x1729x1521</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CSA7151MDAF</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1160,1190</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055</td>\n",
       "      <td>1729</td>\n",
       "      <td>1521</td>\n",
       "      <td>1498</td>\n",
       "      <td>86</td>\n",
       "      <td>LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2520</td>\n",
       "      <td>4055x1729x1521</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>CSA7153ADMN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1330</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>CSA7153ADAN</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1350</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>95</td>\n",
       "      <td>LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>CSA7143ADMP</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1310</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1399</td>\n",
       "      <td>115</td>\n",
       "      <td>LSJA16C3×××××××××,LSJA16C6×××××××××,LSJA16C9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CSA7153ADMB</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1245</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>LSJA16E3×××××××××,LSJA16E6×××××××××,LSJA16E9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>CSA7143ADAP</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1340</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1399</td>\n",
       "      <td>115</td>\n",
       "      <td>LSJA16C3×××××××××,LSJA16C6×××××××××,LSJA16C9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>CSA7153ADAB</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1260</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>LSJA16E3×××××××××,LSJA16E6×××××××××,LSJA16E9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>CSA7143ADAR</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1340</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1399</td>\n",
       "      <td>115</td>\n",
       "      <td>LSJA16C3×××××××××,LSJA16C6×××××××××,LSJA16C9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>CSA7143ADMR</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1310</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612</td>\n",
       "      <td>1804</td>\n",
       "      <td>1488</td>\n",
       "      <td>1399</td>\n",
       "      <td>115</td>\n",
       "      <td>LSJA16C3×××××××××,LSJA16C6×××××××××,LSJA16C9××...</td>\n",
       "      <td>上海汽车集团股份有限公司</td>\n",
       "      <td>2650</td>\n",
       "      <td>4612x1804x1488</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵GT</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>NJ7250ZL4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1645</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>135</td>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>NJ7182ZLA4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1605</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>NJ7250ZL3</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1645</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>\"2497</td>\n",
       "      <td>\"140</td>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>NJ7250ZL3</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1645</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>140</td>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>NJ7182ZLA4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1605</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>NJ7250ZL4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1645</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>135</td>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>NJ7181ZLA4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1605</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBK×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>NJ7250ZL</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1645</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>130</td>\n",
       "      <td>LNPA73BK×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>2949</td>\n",
       "      <td>4949x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>NJ7180TF4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1128</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943</td>\n",
       "      <td>1628</td>\n",
       "      <td>1249</td>\n",
       "      <td>1796</td>\n",
       "      <td>100</td>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943x1628x1249</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>NJ7180TF</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1128</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943</td>\n",
       "      <td>1628</td>\n",
       "      <td>1249</td>\n",
       "      <td>1796</td>\n",
       "      <td>100</td>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943x1628x1249</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>NJ7180TF4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1128</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943</td>\n",
       "      <td>1628</td>\n",
       "      <td>1249</td>\n",
       "      <td>1796</td>\n",
       "      <td>100</td>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943x1628x1249</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>NJ7180TF</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1128</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943</td>\n",
       "      <td>1628</td>\n",
       "      <td>1249</td>\n",
       "      <td>1796</td>\n",
       "      <td>100</td>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943x1628x1249</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>NJ7180TF</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1128</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943</td>\n",
       "      <td>1628</td>\n",
       "      <td>1249</td>\n",
       "      <td>1796</td>\n",
       "      <td>100</td>\n",
       "      <td>LNPEF2BH×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>2375</td>\n",
       "      <td>3943x1628x1249</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵TF</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>NJ7180ZT4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1435</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>88</td>\n",
       "      <td>LNPA7NBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>NJ7180ZT</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1454</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>NJ7250ZT</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1540</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>140</td>\n",
       "      <td>LNPA73BD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>NJ7181ZT4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>NJ7250ZT4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1545</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>135</td>\n",
       "      <td>LNPA73BD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>NJ7182ZTM4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>NJ7182ZTA4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>NJ7182ZTM4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>NJ7182ZTA4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>NJ7180ZT</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1454</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>NJ7250ZT</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1540</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>140</td>\n",
       "      <td>LNPA73BD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>NJ7250ZT4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1545</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>135</td>\n",
       "      <td>LNPA73BD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>NJ7181ZT4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1500</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>NJ7180ZT4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1435</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>88</td>\n",
       "      <td>LNPA7NBD×××××××××</td>\n",
       "      <td>南京汽车集团有限公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>NJ7250ZT</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1540</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>2497</td>\n",
       "      <td>130</td>\n",
       "      <td>LNPA73BD×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>NJ7180ZT4</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1435</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>88</td>\n",
       "      <td>LNPA7NBD×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>NJ7180ZT</td>\n",
       "      <td>名爵</td>\n",
       "      <td>1454</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749</td>\n",
       "      <td>1761</td>\n",
       "      <td>1421</td>\n",
       "      <td>1796</td>\n",
       "      <td>118</td>\n",
       "      <td>LNPA7PBD×××××××××</td>\n",
       "      <td>跃进汽车集团公司</td>\n",
       "      <td>2749</td>\n",
       "      <td>4749x1761x1421</td>\n",
       "      <td>名爵</td>\n",
       "      <td>名爵7</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>311 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0    CSA7152SDMN      名爵        1300      2715       4695      1848   \n",
       "1    CSA7152SDAN      名爵        1320      2715       4695      1848   \n",
       "2    CSA7152SDMP      名爵        1300      2715       4695      1848   \n",
       "3    CSA7152SDAQ      名爵        1320      2715       4695      1848   \n",
       "4    CSA7152SDAP      名爵        1320      2715       4695      1848   \n",
       "5    CSA7152SDMQ      名爵        1300      2715       4695      1848   \n",
       "6    CSA7152SDMQ      名爵        1300      2715       4695      1848   \n",
       "7    CSA7152SDMP      名爵        1300      2715       4695      1848   \n",
       "8    CSA7152SDAQ      名爵        1320      2715       4695      1848   \n",
       "9    CSA7152SDMN      名爵        1300      2715       4695      1848   \n",
       "10   CSA7152SDAN      名爵        1320      2715       4695      1848   \n",
       "11   CSA7152SDAP      名爵        1320      2715       4695      1848   \n",
       "12   CSA7151MDAF      名爵   1160,1190      2520       4055      1729   \n",
       "13   CSA7151MDAG      名爵   1160,1190      2520       4055      1729   \n",
       "14   CSA7151MDAF      名爵   1160,1190      2520       4055      1729   \n",
       "15   CSA7151MDAG      名爵   1160,1190      2520       4055      1729   \n",
       "16   CSA7151MDAG      名爵   1160,1190      2520       4055      1729   \n",
       "17   CSA7151MDAF      名爵   1160,1190      2520       4055      1729   \n",
       "18   CSA7151MDAG      名爵   1160,1190      2520       4055      1729   \n",
       "19   CSA7151MDAF      名爵   1160,1190      2520       4055      1729   \n",
       "20   CSA7151MDAG      名爵   1160,1190      2520       4055      1729   \n",
       "21   CSA7151MDAF      名爵   1160,1190      2520       4055      1729   \n",
       "22   CSA7153ADMN      名爵        1330      2650       4612      1804   \n",
       "23   CSA7153ADAN      名爵        1350      2650       4612      1804   \n",
       "24   CSA7143ADMP      名爵        1310      2650       4612      1804   \n",
       "25   CSA7153ADMB      名爵        1245      2650       4612      1804   \n",
       "26   CSA7143ADAP      名爵        1340      2650       4612      1804   \n",
       "27   CSA7153ADAB      名爵        1260      2650       4612      1804   \n",
       "28   CSA7143ADAR      名爵        1340      2650       4612      1804   \n",
       "29   CSA7143ADMR      名爵        1310      2650       4612      1804   \n",
       "..           ...     ...         ...       ...        ...       ...   \n",
       "281    NJ7250ZL4      名爵        1645      2949       4949      1761   \n",
       "282   NJ7182ZLA4      名爵        1605      2949       4949      1761   \n",
       "283    NJ7250ZL3      名爵        1645      2949       4949      1761   \n",
       "284    NJ7250ZL3      名爵        1645      2949       4949      1761   \n",
       "285   NJ7182ZLA4      名爵        1605      2949       4949      1761   \n",
       "286    NJ7250ZL4      名爵        1645      2949       4949      1761   \n",
       "287   NJ7181ZLA4      名爵        1605      2949       4949      1761   \n",
       "288     NJ7250ZL      名爵        1645      2949       4949      1761   \n",
       "289    NJ7180TF4      名爵        1128      2375       3943      1628   \n",
       "290     NJ7180TF      名爵        1128      2375       3943      1628   \n",
       "291    NJ7180TF4      名爵        1128      2375       3943      1628   \n",
       "292     NJ7180TF      名爵        1128      2375       3943      1628   \n",
       "293     NJ7180TF      名爵        1128      2375       3943      1628   \n",
       "294    NJ7180ZT4      名爵        1435      2749       4749      1761   \n",
       "295     NJ7180ZT      名爵        1454      2749       4749      1761   \n",
       "296     NJ7250ZT      名爵        1540      2749       4749      1761   \n",
       "297    NJ7181ZT4      名爵        1500      2749       4749      1761   \n",
       "298    NJ7250ZT4      名爵        1545      2749       4749      1761   \n",
       "299   NJ7182ZTM4      名爵        1500      2749       4749      1761   \n",
       "300   NJ7182ZTA4      名爵        1500      2749       4749      1761   \n",
       "301   NJ7182ZTM4      名爵        1500      2749       4749      1761   \n",
       "302   NJ7182ZTA4      名爵        1500      2749       4749      1761   \n",
       "303     NJ7180ZT      名爵        1454      2749       4749      1761   \n",
       "304     NJ7250ZT      名爵        1540      2749       4749      1761   \n",
       "305    NJ7250ZT4      名爵        1545      2749       4749      1761   \n",
       "306    NJ7181ZT4      名爵        1500      2749       4749      1761   \n",
       "307    NJ7180ZT4      名爵        1435      2749       4749      1761   \n",
       "308     NJ7250ZT      名爵        1540      2749       4749      1761   \n",
       "309    NJ7180ZT4      名爵        1435      2749       4749      1761   \n",
       "310     NJ7180ZT      名爵        1454      2749       4749      1761   \n",
       "\n",
       "    car_height Displacement power  \\\n",
       "0         1462         1490   124   \n",
       "1         1462         1490   124   \n",
       "2         1462         1490   124   \n",
       "3         1462         1490   124   \n",
       "4         1462         1490   124   \n",
       "5         1462         1490   124   \n",
       "6         1462         1490   124   \n",
       "7         1462         1490   124   \n",
       "8         1462         1490   124   \n",
       "9         1462         1490   124   \n",
       "10        1462         1490   124   \n",
       "11        1462         1490   124   \n",
       "12        1521         1498    86   \n",
       "13        1521         1498    86   \n",
       "14        1521         1498    86   \n",
       "15        1521         1498    86   \n",
       "16        1521         1498    86   \n",
       "17        1521         1498    86   \n",
       "18        1521         1498    86   \n",
       "19        1521         1498    86   \n",
       "20        1521         1498    86   \n",
       "21        1521         1498    86   \n",
       "22        1488         1498    95   \n",
       "23        1488         1498    95   \n",
       "24        1488         1399   115   \n",
       "25        1488         1498    80   \n",
       "26        1488         1399   115   \n",
       "27        1488         1498    80   \n",
       "28        1488         1399   115   \n",
       "29        1488         1399   115   \n",
       "..         ...          ...   ...   \n",
       "281       1421         2497   135   \n",
       "282       1421         1796   118   \n",
       "283       1421        \"2497  \"140   \n",
       "284       1421         2497   140   \n",
       "285       1421         1796   118   \n",
       "286       1421         2497   135   \n",
       "287       1421         1796   118   \n",
       "288       1421         2497   130   \n",
       "289       1249         1796   100   \n",
       "290       1249         1796   100   \n",
       "291       1249         1796   100   \n",
       "292       1249         1796   100   \n",
       "293       1249         1796   100   \n",
       "294       1421         1796    88   \n",
       "295       1421         1796   118   \n",
       "296       1421         2497   140   \n",
       "297       1421         1796   118   \n",
       "298       1421         2497   135   \n",
       "299       1421         1796   118   \n",
       "300       1421         1796   118   \n",
       "301       1421         1796   118   \n",
       "302       1421         1796   118   \n",
       "303       1421         1796   118   \n",
       "304       1421         2497   140   \n",
       "305       1421         2497   135   \n",
       "306       1421         1796   118   \n",
       "307       1421         1796    88   \n",
       "308       1421         2497   130   \n",
       "309       1421         1796    88   \n",
       "310       1421         1796   118   \n",
       "\n",
       "                                                   vin   car_factory 轴距[mm]  \\\n",
       "0    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "1    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "2    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "3    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "4    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "5    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "6    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "7    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "8    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "9    LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "10   LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "11   LSJW54U3×××××××××,LSJW54U6×××××××××,LSJW54U9××...  上海汽车集团股份有限公司   2715   \n",
       "12   LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...  上海汽车集团股份有限公司   2520   \n",
       "13   LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...  上海汽车集团股份有限公司   2520   \n",
       "14   LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...  上海汽车集团股份有限公司   2520   \n",
       "15   LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...  上海汽车集团股份有限公司   2520   \n",
       "16   LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...  上海汽车集团股份有限公司   2520   \n",
       "17   LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...  上海汽车集团股份有限公司   2520   \n",
       "18   LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...  上海汽车集团股份有限公司   2520   \n",
       "19   LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...  上海汽车集团股份有限公司   2520   \n",
       "20   LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...  上海汽车集团股份有限公司   2520   \n",
       "21   LSJZ14U3×××××××××,LSJZ14U6×××××××××,LSJZ14U9××...  上海汽车集团股份有限公司   2520   \n",
       "22   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "23   LSJA16U3×××××××××,LSJA16U6×××××××××,LSJA16U9××...  上海汽车集团股份有限公司   2650   \n",
       "24   LSJA16C3×××××××××,LSJA16C6×××××××××,LSJA16C9××...  上海汽车集团股份有限公司   2650   \n",
       "25   LSJA16E3×××××××××,LSJA16E6×××××××××,LSJA16E9××...  上海汽车集团股份有限公司   2650   \n",
       "26   LSJA16C3×××××××××,LSJA16C6×××××××××,LSJA16C9××...  上海汽车集团股份有限公司   2650   \n",
       "27   LSJA16E3×××××××××,LSJA16E6×××××××××,LSJA16E9××...  上海汽车集团股份有限公司   2650   \n",
       "28   LSJA16C3×××××××××,LSJA16C6×××××××××,LSJA16C9××...  上海汽车集团股份有限公司   2650   \n",
       "29   LSJA16C3×××××××××,LSJA16C6×××××××××,LSJA16C9××...  上海汽车集团股份有限公司   2650   \n",
       "..                                                 ...           ...    ...   \n",
       "281                                  LNPA73BK×××××××××    南京汽车集团有限公司   2949   \n",
       "282                                  LNPA7PBK×××××××××    南京汽车集团有限公司   2949   \n",
       "283                                  LNPA73BK×××××××××    南京汽车集团有限公司   2949   \n",
       "284                                  LNPA73BK×××××××××    南京汽车集团有限公司   2949   \n",
       "285                                  LNPA7PBK×××××××××    南京汽车集团有限公司   2949   \n",
       "286                                  LNPA73BK×××××××××    南京汽车集团有限公司   2949   \n",
       "287                                  LNPA7PBK×××××××××    南京汽车集团有限公司   2949   \n",
       "288                                  LNPA73BK×××××××××      跃进汽车集团公司   2949   \n",
       "289                                  LNPEF2BH×××××××××    南京汽车集团有限公司   2375   \n",
       "290                                  LNPEF2BH×××××××××    南京汽车集团有限公司   2375   \n",
       "291                                  LNPEF2BH×××××××××    南京汽车集团有限公司   2375   \n",
       "292                                  LNPEF2BH×××××××××    南京汽车集团有限公司   2375   \n",
       "293                                  LNPEF2BH×××××××××      跃进汽车集团公司   2375   \n",
       "294                                  LNPA7NBD×××××××××    南京汽车集团有限公司   2749   \n",
       "295                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "296                                  LNPA73BD×××××××××    南京汽车集团有限公司   2749   \n",
       "297                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "298                                  LNPA73BD×××××××××    南京汽车集团有限公司   2749   \n",
       "299                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "300                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "301                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "302                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "303                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "304                                  LNPA73BD×××××××××    南京汽车集团有限公司   2749   \n",
       "305                                  LNPA73BD×××××××××    南京汽车集团有限公司   2749   \n",
       "306                                  LNPA7PBD×××××××××    南京汽车集团有限公司   2749   \n",
       "307                                  LNPA7NBD×××××××××    南京汽车集团有限公司   2749   \n",
       "308                                  LNPA73BD×××××××××      跃进汽车集团公司   2749   \n",
       "309                                  LNPA7NBD×××××××××      跃进汽车集团公司   2749   \n",
       "310                                  LNPA7PBD×××××××××      跃进汽车集团公司   2749   \n",
       "\n",
       "          长×宽×高[mm] brand_y style  factory  \n",
       "0    4695x1848x1462      名爵   名爵6        7  \n",
       "1    4695x1848x1462      名爵   名爵6        7  \n",
       "2    4695x1848x1462      名爵   名爵6        7  \n",
       "3    4695x1848x1462      名爵   名爵6        7  \n",
       "4    4695x1848x1462      名爵   名爵6        7  \n",
       "5    4695x1848x1462      名爵   名爵6        7  \n",
       "6    4695x1848x1462      名爵   名爵6        7  \n",
       "7    4695x1848x1462      名爵   名爵6        7  \n",
       "8    4695x1848x1462      名爵   名爵6        7  \n",
       "9    4695x1848x1462      名爵   名爵6        7  \n",
       "10   4695x1848x1462      名爵   名爵6        7  \n",
       "11   4695x1848x1462      名爵   名爵6        7  \n",
       "12   4055x1729x1521      名爵   名爵3        4  \n",
       "13   4055x1729x1521      名爵   名爵3        4  \n",
       "14   4055x1729x1521      名爵   名爵3        4  \n",
       "15   4055x1729x1521      名爵   名爵3        4  \n",
       "16   4055x1729x1521      名爵   名爵3        4  \n",
       "17   4055x1729x1521      名爵   名爵3        4  \n",
       "18   4055x1729x1521      名爵   名爵3        4  \n",
       "19   4055x1729x1521      名爵   名爵3        4  \n",
       "20   4055x1729x1521      名爵   名爵3        4  \n",
       "21   4055x1729x1521      名爵   名爵3        4  \n",
       "22   4612x1804x1488      名爵  名爵GT       20  \n",
       "23   4612x1804x1488      名爵  名爵GT       20  \n",
       "24   4612x1804x1488      名爵  名爵GT       20  \n",
       "25   4612x1804x1488      名爵  名爵GT       20  \n",
       "26   4612x1804x1488      名爵  名爵GT       20  \n",
       "27   4612x1804x1488      名爵  名爵GT       20  \n",
       "28   4612x1804x1488      名爵  名爵GT       20  \n",
       "29   4612x1804x1488      名爵  名爵GT       20  \n",
       "..              ...     ...   ...      ...  \n",
       "281  4949x1761x1421      名爵   名爵7       24  \n",
       "282  4949x1761x1421      名爵   名爵7       24  \n",
       "283  4949x1761x1421      名爵   名爵7       24  \n",
       "284  4949x1761x1421      名爵   名爵7       24  \n",
       "285  4949x1761x1421      名爵   名爵7       24  \n",
       "286  4949x1761x1421      名爵   名爵7       24  \n",
       "287  4949x1761x1421      名爵   名爵7       24  \n",
       "288  4949x1761x1421      名爵   名爵7       24  \n",
       "289  3943x1628x1249      名爵  名爵TF        6  \n",
       "290  3943x1628x1249      名爵  名爵TF        6  \n",
       "291  3943x1628x1249      名爵  名爵TF        6  \n",
       "292  3943x1628x1249      名爵  名爵TF        6  \n",
       "293  3943x1628x1249      名爵  名爵TF        6  \n",
       "294  4749x1761x1421      名爵   名爵7       24  \n",
       "295  4749x1761x1421      名爵   名爵7       24  \n",
       "296  4749x1761x1421      名爵   名爵7       24  \n",
       "297  4749x1761x1421      名爵   名爵7       24  \n",
       "298  4749x1761x1421      名爵   名爵7       24  \n",
       "299  4749x1761x1421      名爵   名爵7       24  \n",
       "300  4749x1761x1421      名爵   名爵7       24  \n",
       "301  4749x1761x1421      名爵   名爵7       24  \n",
       "302  4749x1761x1421      名爵   名爵7       24  \n",
       "303  4749x1761x1421      名爵   名爵7       24  \n",
       "304  4749x1761x1421      名爵   名爵7       24  \n",
       "305  4749x1761x1421      名爵   名爵7       24  \n",
       "306  4749x1761x1421      名爵   名爵7       24  \n",
       "307  4749x1761x1421      名爵   名爵7       24  \n",
       "308  4749x1761x1421      名爵   名爵7       24  \n",
       "309  4749x1761x1421      名爵   名爵7       24  \n",
       "310  4749x1761x1421      名爵   名爵7       24  \n",
       "\n",
       "[311 rows x 16 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('名爵_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
